<?php

/*
 * CopyRight  : (C)2012-2099 HaoTeam Inc.
 * Document   : UserWithdraw.php
 * Created on : 2023-4-5 16:40:19
 * Author     : Tiger <1192851302@qq.com>
 * Description: This is NOT a freeware, use is subject to license terms.
 *              这即使是一个免费软件,使用时也请遵守许可证条款,得到当时人书面许可.
 *              未经书面许可,不得翻版,翻版必究;版权归属 HaoTeam Inc;
 */

namespace app\models;

use think\Model;

/**
 * 
 * Class UserWithdraw
 * Tiger <1192851302@qq.com> 2023-4-5 16:40:19
 */
class UserWithdraw extends Model {

    /**
     * 获取数据列表-分页
     * @author Tiger <1192851302@qq.com>
     * @param array $where
     * @return array
     */
    public static function getList($where) {
        $model = self::alias('a')
                ->join('user u ', 'u.id= a.user_id');
        if (!empty($where['search'])) {
            $model->where('u.nickname|u.mobile', 'LIKE', '%' . $where['search'] . '%');
        }
        if (!empty($where['date'])) {
            [$start_date, $end_date] = explode(' - ', $where['date']);
            $start_date && $end_date ? $model->whereBetweenTime('a.time', $start_date, $end_date . ' 23:59:59') : '';
        }
        if (!empty($where['status'])) {
            $model->where('a.status', $where['status']);
        }
        $models = $model->order('a.time desc')->field(['a.*', 'u.nickname', 'u.mobile'])
                ->paginate(input('limit', 10));
        return [
            'code' => 0,
            'items' => $models->items(),
            'total' => $models->total()
        ];
    }

}
